USE [aircond]
GO

/****** Object:  Table [dbo].[USERDETAIL_USERGROUP]    Script Date: 03/15/2013 00:02:36 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[USERDETAIL_USERGROUP](
	[USERDETAIL_ID] [numeric](19, 0) NOT NULL,
	[USERGROUP_ID] [numeric](19, 0) NOT NULL
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[USERDETAIL_USERGROUP]  WITH CHECK ADD  CONSTRAINT [FKFF3544D1996EE567] FOREIGN KEY([USERDETAIL_ID])
REFERENCES [dbo].[USERDETAIL] ([USERDETAIL_ID])
GO

ALTER TABLE [dbo].[USERDETAIL_USERGROUP] CHECK CONSTRAINT [FKFF3544D1996EE567]
GO

ALTER TABLE [dbo].[USERDETAIL_USERGROUP]  WITH CHECK ADD  CONSTRAINT [FKFF3544D1B37FEE6D] FOREIGN KEY([USERGROUP_ID])
REFERENCES [dbo].[USERGROUP] ([USERGROUP_ID])
GO

ALTER TABLE [dbo].[USERDETAIL_USERGROUP] CHECK CONSTRAINT [FKFF3544D1B37FEE6D]
GO

